package com.jxc.model.po;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;

@Entity
@Table(name="fhtj")
public class Fhtj extends IdEntity implements Serializable{

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	
	/*视图创建语句
	* CREATE OR REPLACE VIEW fhtj  AS 
	* SELECT dl.id id,dl.agency_id,SUM(dl.num) fhsum,u.user_name 
	* FROM `kcgl_deliverlist` dl JOIN `qxgl_user` u ON 
	* dl.dealer_id=u.id GROUP BY dl.dealer_id
	*/
	
	private Long agencyid;
	private Double fhsum;
	private String dealername;
	
	@Column(name = "FHSUM")
	public Double getFhsum() {
		return fhsum;
	}
	public void setFhsum(Double fhsum) {
		this.fhsum = fhsum;
	}
	
	@Column(name = "AGENCY_ID")
	public Long getAgencyid() {
		return agencyid;
	}
	public void setAgencyid(Long agencyid) {
		this.agencyid = agencyid;
	}
	
	@Column(name = "DEALER_NAME")
	public String getDealername() {
		return dealername;
	}
	public void setDealername(String dealername) {
		this.dealername = dealername;
	}

	

}
